<?php
abstract class ContentHelper  {
   
  /**
  * Function to get additional columns for article/section/category
  * @param id
  * @param view
  */
   public static function getAdditionalColumns($id, $view){
     // Load the template name from the database
		$db =& JFactory::getDBO();
		$results = '';
		if ($view){
			switch ($view){
				case 'article':
					$query = 'SELECT article_transcript,schemaorg_meta_name,schemaorg_meta_description, article_image,article_video,article_short_desc,created,modified'
							. ' FROM #__content'
							. ' WHERE id = ' . "'" . $id . "'"			
							;							
					$db->setQuery( $query );
					$results = $db->loadObject();
				break;
			}
		}
		
	return $results;
   }

	/**
	* Get Site URL function
	*
	*/
   public static function getSiteUrl(){
      $mainframe = JFactory::getApplication('site');
      if( isset($mainframe) && is_object($mainframe)) {
         return $mainframe->isAdmin() ? $mainframe->getSiteURL() : JURI::base();
      } else {
         return JURI::base();
      }
   }
}
?>